Даны 2 таблицы с названиями orders и products c колонками "order_id", "customer_id", "product_id", "order_date", "quantity" и "product_id", "product_name", "unit_price". Какой из следующих SQL запросов вернет топ-5 покупателей, которые потратили больше всего в категории "Electronics"?
A) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_name LIKE '%Electronics%' GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
B) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE '%Electronics%') GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
C) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE 'Electronics%') GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
D) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name = 'Electronics') GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
Даны 2 таблицы с названиями orders и products c колонками "order_id", "customer_id", "product_id", "order_date", "quantity" и "product_id", "product_name", "unit_price". Какой из следующих SQL запросов вернет топ-5 покупателей, которые потратили больше всего в категории "Electronics"?
A) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_name LIKE '%Electronics%' GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
B) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE '%Electronics%') GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
C) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE 'Electronics%') GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
D) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent FROM orders o JOIN products p ON o.product_id = p.product_id WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name = 'Electronics') GROUP BY o.customer_id ORDER BY total_spent DESC LIMIT 5;
Ответить на вопрос можно ниже ⬇️
BY SQL для тестировщика
Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283
You can’t. What you can do, though, is use WhatsApp’s and Telegram’s web platforms to transfer stickers. It’s easy, but might take a while.Open WhatsApp in your browser, find a sticker you like in a chat, and right-click on it to save it as an image. The file won’t be a picture, though—it’s a webpage and will have a .webp extension. Don’t be scared, this is the way. Repeat this step to save as many stickers as you want.Then, open Telegram in your browser and go into your Saved messages chat. Just as you’d share a file with a friend, click the Share file button on the bottom left of the chat window (it looks like a dog-eared paper), and select the .webp files you downloaded. Click Open and you’ll see your stickers in your Saved messages chat. This is now your sticker depository. To use them, forward them as you would a message from one chat to the other: by clicking or long-pressing on the sticker, and then choosing Forward.
How to Use Bitcoin?
n the U.S. people generally use Bitcoin as an alternative investment, helping diversify a portfolio apart from stocks and bonds. You can also use Bitcoin to make purchases, but the number of vendors that accept the cryptocurrency is still limited. Big companies that accept Bitcoin include Overstock, AT&T and Twitch. You may also find that some small local retailers or certain websites take Bitcoin, but you’ll have to do some digging. That said, PayPal has announced that it will enable cryptocurrency as a funding source for purchases this year, financing purchases by automatically converting crypto holdings to fiat currency for users. “They have 346 million users and they’re connected to 26 million merchants,” says Spencer Montgomery, founder of Uinta Crypto Consulting. “It’s huge.”
